package com.xiguaji.tiktok.v1.ins.dic.repository;

import com.xiguaji.tiktok.v1.ins.dic.model.InsDicCategory;
import org.springframework.data.jdbc.repository.query.Query;
import org.springframework.data.repository.CrudRepository;

import java.util.List;

public interface InsDicCategoryRepository extends CrudRepository<InsDicCategory,Long> {

    @Query("select distinct overall_category from ins_dic_category order by overall_category ")
    List<InsDicCategory> findOverall();

    List<InsDicCategory> findByOverallCategoryOrderByCategory(String overallCategory);
}
